USE clothing 

go 

IF EXISTS(SELECT * 
          FROM   sys.objects 
          WHERE  object_id = Object_id(N'train_info') 
                 AND type IN ( N'U' )) 
  BEGIN 
      DROP TABLE train_info 
  END 

go 

CREATE TABLE train_info 
  ( 
     tid     INT IDENTITY(1, 1) NOT NULL, 
     eid     VARCHAR(10) NOT NULL, 
     tdate   VARCHAR(10), 
     course  NVARCHAR(20) NOT NULL, 
     remark  NVARCHAR(200) 
     PRIMARY KEY CLUSTERED ( tid ASC )WITH (ignore_dup_key=OFF) ON [primary] 
  ) 
ON [primary] 

go 